package com.ruoyi.bizsys.mapper;

import java.util.List;

import com.ruoyi.bizsys.domain.CollectionReduceOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.bizsys.vo.CollectionReduceOrderVo;

/**
 * 催收减免订单Mapper接口
 *
 * @author african-loan
 * @date 2022-08-15
 */
public interface CollectionReduceOrderMapper extends BaseMapper<CollectionReduceOrder>{

    /**
     *  loan_serial_no = #{loanSerialNo} and exp_time_at > SYSDATE() and  status  = 1
     * @param loanSerialNo
     * @return
     */
    CollectionReduceOrder getCanUseDetailByloanSerialNo(String loanSerialNo);
    List<CollectionReduceOrderVo> selectCollectionReduceOrderVoList(CollectionReduceOrder collectionReduceOrder);

    CollectionReduceOrder selectCollectionReduceOrderByLoanNo(String loanSerialNo);

    CollectionReduceOrder selectOnAppleyingByLoanNo(String loanSerialNo);

    CollectionReduceOrder selectNotUseByLoanNo(String loanSerialNo);
}